|
|
|
|
|
Excel 2007 Intermediate
|
|
|
|
The Excel 2007 Intermediate tutorial takes you step by step through intermediate spreadsheet tasks as specified in the Microsoft Certified Application Specialist (MCAS) exam (77-602). |
|
|
|
Working with Existing Spreadsheets |
Modifying Worksheets |
|
Formatting Worksheets |
|
Custom and Conditional Formats |
|
Cell and Table Styles |
Workspaces and Views |
Saving a Workspace |
|
Excel Views |
|
Using Custom Views |
Presenting Data Visually |
Illustrations |
|
Outlining |
|
Sorting and Filtering Data |
|
Trendlines |
Spreadsheet Tools |
Auditing Tools |
|
Scenario Manager |
|
Using Macros |
Importing, Exporting and Pivot Tables |
Importing, Exporting and Queries |
|
Working with PivotTables |
|
|
|
|
© KNOWHOW2 Pty Ltd
|
|
|